CREATE TABLE [dbo].[FundFundType]
(
[FundFundTypeKey] [uniqueidentifier] NOT NULL,
[FundKey] [uniqueidentifier] NOT NULL,
[FundTypeKey] [uniqueidentifier] NOT NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[FundFundType] ADD CONSTRAINT [PK_FundFundType] PRIMARY KEY CLUSTERED ([FundFundTypeKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_FundFundType_FundKey] ON [dbo].[FundFundType] ([FundKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_FundFundType_FundTypeKey] ON [dbo].[FundFundType] ([FundTypeKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FundFundType] ADD CONSTRAINT [FK_FundFundType_Fund] FOREIGN KEY ([FundKey]) REFERENCES [dbo].[Fund] ([FundKey])
GO
ALTER TABLE [dbo].[FundFundType] ADD CONSTRAINT [FK_FundFundType_FundTypeRef] FOREIGN KEY ([FundTypeKey]) REFERENCES [dbo].[FundTypeRef] ([FundTypeKey])
GO